package com.K_lificapp;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;

public class AlumnosSQLiteHelper extends SQLiteOpenHelper {
	public static final String TABLE_ALUMNOS = "Alumnos";
	  public static final String IDALUMNO = "IdAlumno";
	  public static final String NOMBRE = "nombre";
	  public static final String APELLIDOP = "apellidoP";
	  public static final String APELLIDOM = "apellidoM";
	  public static final String EMAIL = "email";

	  private static final String DATABASE_NAME = "k-lificapp.db";
	  private static final int DATABASE_VERSION = 1;

	  // Database creation sql statement
	  private static final String DATABASE_CREATE = "create table "
	      + TABLE_ALUMNOS + "(" + IDALUMNO + " integer primary key autoincrement, " 
	      + NOMBRE + " text not null, " 
	      + APELLIDOP + " text not null, " 
	      + APELLIDOM + " text not null, " 
	      + EMAIL + " text not null )";

	  public AlumnosSQLiteHelper(Context context) {
	    super(context, DATABASE_NAME, null, DATABASE_VERSION);
	  }

	  @Override
	  public void onCreate(SQLiteDatabase database) {
	    database.execSQL(DATABASE_CREATE);
	  }

	  @Override
	  public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
	    Log.w(AlumnosSQLiteHelper.class.getName(),
	        "Upgrading database from version " + oldVersion + " to "
	            + newVersion + ", which will destroy all old data");
	    db.execSQL("DROP TABLE IF EXISTS " + TABLE_ALUMNOS);
	    onCreate(db);
	  }
}
